SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create view [dbo].[alumnosrepetidosjines]
as
SELECT alumno, Organizacion, Aniolectivo, count(*)as cantidad FROM tb_Inscripciones WHERE AnioLectivo = 2009 GROUP BY alumno, Organizacion, Aniolectivo HAVING count(*) > 1

 


GO
